Visual Cafe Pro Language Reference Variable index | Method index | Bottom

Class: symantec.itools.db.pro.AutoDetail

Purpose Adds a detail RelationView to a MultiView.
Hierarchy java.lang.Object
|
+----symantec.itools.db.pro.Request
|
+----symantec.itools.db.pro.AutoDetail
Syntax public class AutoDetail
extends Request
Description AutoDetail adds a detail RelationView to a MultiView.
See also RelationView
MultiView
Request

Variable Index

Method index | Top | Bottom
MANY_TO_MANY
o Specifies the many to many value for a cardinality setting.
MANY_TO_ONE
o Specifies the many to one value for a cardinality setting.
ONE_TO_MANY
o Specifies the one to many value for a cardinality setting.
ONE_TO_ONE
o Specifies the one to one value for a cardinality setting.

Method Index

Variable index | Top | Bottom
executeRequest( )
o Creates a detail RelationView based on an AutoDetail object.
getDetailProperties( )
o Returns an AutoDetail's detail properties.
join(int, int)
o Specifies how to set a parameter in an AutoDetail's SQL statement from a master RelationView's projection.
setDetailProperties(Properties)
o Sets an AutoDetail's detail properties.

Variables

Variable index | Method index | Top | Bottom

Variable: MANY_TO_MANY

Purpose Specifies the many to many value for a cardinality setting.
Syntax public final static String MANY_TO_MANY

Variable: MANY_TO_ONE

Purpose Specifies the many to one value for a cardinality setting.
Syntax public final static String MANY_TO_ONE

Variable: ONE_TO_MANY

Purpose Specifies the one to many value for a cardinality setting.
Syntax public final static String ONE_TO_MANY

Variable: ONE_TO_ONE

Purpose Specifies the one to one value for a cardinality setting.
Syntax public final static String ONE_TO_ONE

Methods

Variable index | Method index | Top | Bottom

Method: executeRequest

Purpose Creates a detail RelationView based on an AutoDetail object.
Syntax public RelationView executeRequest( ) throws SQLException
Parameters None.
Description Creates a detail RelationView based on an AutoDetail's ConnectionInfo, SQL string, Request properties, and detail properties. The master RelationView is the one that the AutoDetail is based on. Each time the master RelationView's current record changes, the detail RelationView creates a new set of records based on the join settings.
Overrides executeRequest in class Request
See also RelationView

Method: getDetailProperties

Purpose Returns an AutoDetail's detail properties.
Syntax public Properties getDetailProperties( )
Parameters None.
Description Returns the detail object properties.

Method: join

Purpose Specifies how to set a parameter in an AutoDetail's SQL statement from a master RelationView's projection.
Syntax public void join(int paramIndex,
int resultCol) throws SQLException
Parameters paramIndex = Parameter to set from the resultCol value.

resultCol = Result column or projection number to set the paramIndex parameter to.

Description Specifies how to set a parameter in an AutoDetail's SQL statement from a master RelationView's projection.

Method: setDetailProperties

Purpose Sets an AutoDetail's detail properties.
Syntax public void setDetailProperties(Properties detailProps)
Parameters Properties = java.util.Properties object containing detail properties. This object defines the cardinality property which is the cardinality setting for a detail RelationView created by a SQL statement. Possible values:
o ONE_TO_ONE
o ONE_TO_MANY
o MANY_TO_ONE
o MANY_TO_MANY
o The default value is ONE_TO_MANY.
Description Sets detail properties. Since these properties have default values, you don't need to call setDetailProperties to execute a Request.
See also RelationView
Variable index | Method index | Top

Copyright © 1996 Symantec Corporation. All rights reserved.